<html>
<head>
    <title>Suspence Clearence Register</title>
</head>
<body>

<div align="center"> Suspence Clearence Register of {{start_date}} to {{end_date}}
<table border='1'>
	<tr>
		<td>S.No</td>
		<td>Ref.No </td>
		<td>Date</td>
		<td>Receipt</td>
		<td>Address</td>
		<td>Type of Material</td>
		<td>College Income {{collegeincome }}%</td>
		<td>Admin Charges {{admincharge}}%</td>
		<td>Consultancy</td>
		<td>Dev. Fund</td>
                <td>Work charges</td>
                <td>Other charges</td>
                <td>Boring charges internal</td>
		<td>Total</td>
 	</tr>
{% if amount %}
    {% for amounts in amount %}
    {% for sus in suspence %}  
    {% for susdetail in suspencedetail %}
		 {% if amounts.job__id == sus.job_id %}  
		 {% if sus.job_id == susdetail.job_id %}  	
         <tr>
		
            <td>{{forloop.counter}}</td>            
			<td>{{amounts.job__id}}</td> 
			<td> {{ amounts.job__date  }}</td>
			<td> {{ amounts.job__job_no }}</td>
			<td> {{amounts.job__client__client__first_name}}</td>
			<td> {{ sus.field__name }}</td>
			<td>{{amounts.college_income}}</td>
			<td>{{amounts.admin_charge}}</td>
			<td>{{amounts.consultancy_asst}}</td>
			<td>{{amounts.development_fund}}</td>
                        <td>{{susdetail.work_charge}}</td>
			<td>{{ susdetail.labour_charge|add:susdetail.boring_charge_external|add:susdetail.car_taxi_charge}} </td>
			<td>{{susdetail.boring_charge_internal}}</td>
			<td>{{amounts.unit_price}}</td>
			
		</tr>
        	{% endif  %}
		{% endif  %}
	{% endfor %}
        {% endfor %}
	{% endfor %}
{% endif  %}

		<tr>
			<td><b>  </b></td>
			<td><b> </b></td>
			 <td><b></b></td>
			<td><b>  </b></td>
			<td><b> </b></td>
			<td><b> </b></td>
			<td><b> {{college_income}} </b></td>
	         <td><b>{{admin_charge}}</b></td>
	        <td><b>	{{consultancy_asst}} </b></td>
	        <td><b> {{development_fund}}</b></td>
                <td><b> </b></td>
              <td><b> </b></td>
               <td><b> </b></td>
              
	        
	         <td><b>{{total}} </b></td>
	</tr>	
</table>
</div>


</body>
	


